﻿CREATE TABLE [dbo].[dim_Zweck] (
    [ZweckID]        INT        NOT NULL,
    [ZweckName]      NCHAR (31) NOT NULL,
    [ParentZweckID]  INT        NULL,
    [SubKategorieID] INT        NULL,
    [Budget_monthly_2014] NUMERIC(8, 2) NULL, 
    CONSTRAINT [PK_tblZweck] PRIMARY KEY CLUSTERED ([ZweckID] ASC),
    CONSTRAINT [FK_tblZweck_tblSubKategorie] FOREIGN KEY ([SubKategorieID]) REFERENCES [dbo].[dim_KategorieSub] ([SubKategorieID])
);

